﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DeviceRubbishQuery.aspx.cs" Inherits="DeviceRubbishQuery" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>无标题页</title>
<link href="css/style.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form method="post" id="frmAnnounce" runat="server">
      <table width=842 border=0 cellpadding=0 cellspacing=0 align="center">
        <tr style="color:blue;font-size:14px;">
	  <td style="height: 14px; width: 842px;">
          <img src="images/list.gif" width=14px height=14px>设备报废管理--&gt;报废信息查询</td>
        </tr>
        <tr>
        <td style="width: 842px;"　valign=top>
            设备名称:<asp:TextBox ID="DeviceName" runat="server" Width="62px"></asp:TextBox>设备类别:<asp:DropDownList
                  ID="DeviceType" runat="server" Width="63px" DataSourceID="DeviceTypeNameDataSource" DataTextField="deviceTypeName" DataValueField="deviceTypeName">
              </asp:DropDownList>&nbsp; 开始时间:<asp:TextBox ID="StartTime" runat="server" Width="65px"></asp:TextBox>
              <input class="submit" name="Button" onclick="seltime('StartTime')" style="width: 30px"
                  type="button" value="选择" />结束时间:<asp:TextBox ID="EndTime" runat="server" Width="64px"></asp:TextBox>
              <input class="submit" name="Button" onclick="seltime('EndTime')" style="width: 30px"
                  type="button" value="选择" />
              <asp:Button ID="Btn_Query" runat="server" OnClick="Btn_Query_Click" Text="查询" /><br />
            <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px"
                CellPadding="3" CellSpacing="2" DataSourceID="DeviceRubbishDataSource"
                Width="592px" OnRowDataBound="GridView1_RowDataBound">
                <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
                <Columns>
                    <asp:BoundField DataField="deviceName" HeaderText="设备名称" SortExpression="deviceName" />
                    <asp:BoundField DataField="deviceTypeName" HeaderText="设备类别" SortExpression="deviceTypeName" />
                    <asp:BoundField DataField="deviceRubbishTime" HeaderText="报废时间" SortExpression="deviceRubbishTime" />
                    <asp:BoundField DataField="deviceRubbishReason" HeaderText="报废原因" SortExpression="deviceRubbishReason" />
                    <asp:BoundField DataField="deprecitionMoney" HeaderText="折旧金额" SortExpression="deprecitionMoney" />
                </Columns>
                <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
                <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
                <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
                <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
            </asp:GridView>
            <asp:SqlDataSource ID="DeviceRubbishDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
                SelectCommand="SELECT * FROM [rubbishInfoView]"></asp:SqlDataSource>
            &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
        </tr>
      </table>
        <asp:SqlDataSource ID="DeviceTypeNameDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            SelectCommand="SELECT [deviceTypeName] FROM [deviceType]"></asp:SqlDataSource>
    </form>
</body>
</html>